text function, that is, the formula can be a function of processing the text string. For example, you can change the case or to determine the length of the text string; can remove or replace certain characters, such as certain characters.

(a) case conversion

LOWER - a text string in all uppercase letters converted to lowercase letters.

UPPER - National Cheng Kung University will write the form of text conversion.

PROPER - will be the first letter of the text string and any non-alphanumeric characters after the first letter uppercase conversion. The rest of the letters will be converted to lowercase.

These three functions are the basic functions of grammatical form (text). Examples illustrate:

String has been for: pLease ComE Here! Can see that as a result of the importation of non-standard, this case of abuse.

Through the above three functions can be converted to display text styles, making the text has become normative. See Figure 1

Lower (pLease ComE Here!) = Please come here!

upper (pLease ComE Here!) = PLEASE COME HERE!

proper (pLease ComE Here!) = Please Come Here!

(b) removed some of the character string

You can use the Mid, Left, Right and other functions from within the access part of a long string of characters. Specific syntax for the

LEFT functions: LEFT (text, num_chars) which is contained in Text to extract the text string of characters. LEFT specify Num_chars extracted from the number of characters.

MID function: MID (text, start_num, num_chars) which is contained in Text to extract the text string of characters. Start_num is to extract the text of the first character position.

RIGHT function: RIGHT (text, num_chars) which is contained in Text to extract the text string of characters. RIGHT hope Num_chars specified number of characters extracted.

For example, from the string "This is an apple." Characters were taken out "This", "apple", "is" written for the specific function.

LEFT ( "This is an apple", 4) = This

RIGHT ( "This is an apple", 5) = apple

MID ( "This is an apple", 6,2) = is